home *** CD-ROM | disk | FTP | other *** search
- * MAILPRNT.PRG
- *
- SET TOP MARGIN TO 0
- SET BOTTOM MARGIN TO 0
- SET HEADING TO
- SET HEADING2 TO
- SET FOOTER TO
- Y.READNO = 1
- Y.PRINT_PAR = SPACE(80)
- ERASE
- USE MAILLIST
- DO WHILE T
- @ 00,00 SAY CENTER('PRINT LABELS',79)
- @ 01,00 SAY CENTER('F2=HELP F3 = QUIT F8=ERASE',79)
- @ 05,00 SAY 'PLEASE ENTER SELECTION CRITERIA OR RETURN FOR NONE.'
- @ 09,00 SAY 'EXAMPLE : STATE = "CA"'
- @ 10,00 SAY ' LAST_NAME > "D"'
- @ 11,00 SAY ' COMPANY > " " AND STATE <> "WA"'
- @ 13,00 SAY 'FIELD NAMES :'
- @ 14,00 SAY 'FIRST_NAME : LAST_NAME : ADDRESS1 : ADDRESS2 : CITY : STATE : ZIP : PHONE'
- @ 16,00 SAY 'PLEASE INCLUDE THE ENTIRE FIELD NAME AND ENCLOSE YOUR DATA IN QUOTES.'
- @ 17,00 SAY 'PRESS THE F2 KEY FOR MORE HELP.'
- @ 07,00 GET Y.PRINT_PAR PICTURE DUPCHAR(33,80)
- READ GETNO Y.READNO
- DO CASE
- CASE LASTKEY() = 189 OR LASTKEY() = 27 OR LASTKEY() = 17| F3 OR ESC OR ^Q
- CLOSE ALL
- RETURN
- CASE LASTKEY() = 188 OR LASTKEY() = 8 | F2 OR ^H
- DO MAILPRH1
- LOOP
- CASE LEN(TRIM(Y.PRINT_PAR)) = 0
- EXIT
- CASE TYPE(Y.PRINT_PAR) = 'L'
- EXIT
- OTHERWISE
- @ 24,00 SAY 'SOME THING IN YOUR PARAMETERS WAS NOT CORRECT. PLEASE REENTER'
- BEEP
- LOOP
- ENDCASE
- ENDDO
- DO WHILE T
- ERASE
- @ 00,00 SAY CENTER ('PRINT LABELS',79)
- ASSIGN VMENU('*','PRINT IN NAME ORDER*PRINT IN COMPANY ORDER*PRINT IN ZIP CODE ORDER*QUIT',5,1)
- DO CASE
- CASE VMENU() = 1
- SET INDEX TO MAILNAME
- CASE VMENU() = 2
- SET INDEX TO MAILCOMP
- CASE VMENU() = 3
- SET INDEX TO MAILZIP
- CASE NRANGE(VMENU(),40,44)
- DO MAILPRH2
- LOOP
- OTHERWISE
- RETURN
- ENDCASE
- EXIT
- ENDDO
- DO WHILE T
- Y.ANS = ' '
- ERASE
- @ 0,0 SAY CENTER ('PRINT LABELS',79)
- @ 10,00 SAY 'PLEASE READY PRINTER PRESS ANY KEY TO CONTINUE OR P TO PRINT TEST :' GET Y.ANS
- READ
- IF !(Y.ANS) = 'P'
- SET PRINT ON
- SET CONSOLE OFF
- ? 'XXXXXXXXXX'
- ? 'XXXXXXXXXX'
- ? 'XXXXXXXXXX'
- ? 'XXXXXXXXXX'
- ?
- ?
- SET PRINT OFF
- SET CONSOLE ON
- ELSE
- EXIT
- ENDIF
- ENDDO
- SET FILTER TO &Y.PRINT_PAR
- SET DELETED ON
- GO TOP
- ERASE
- @ 00,00 SAY CENTER('PRINT LABELS',79)
- @ 10,00 SAY 'PRINTING....... PRESS ANY TO ABORT.'
- SET PRINT ON
- SET CONSOLE OFF
- SET ESCAPE OFF
- DO WHILE NOT EOF(FP)
- IF INKEY() <> 0
- CLOSE ALL
- SET DELETED OFF
- EXIT
- ENDIF
- IF P.LAST_NAME <> ' ' AND P.FIRST_NAME <> ' '
- ? P.FIRST_NAME-' '+P.LAST_NAME
- ENDIF
- IF P.COMPANY <> ' '
- ? P.COMPANY
- ENDIF
- ? P.ADDRESS1
- IF P.ADDRESS2 <> ' '
- ? P.ADDRESS2
- ENDIF
- ? TRIM(CITY)+', '+STATE+' '+ZIP
- ?
- IF P.LAST_NAME = ' ' AND P.FIRST_NAME = ' '
- ?
- ENDIF
- IF P.COMPANY = ' '
- ?
- ENDIF
- IF P.ADDRESS2 = ' '
- ?
- ENDIF
- SKIP
- ENDDO
- CLOSE ALL
- SET DELETED OFF
- SET PRINT OFF
- SET CONSOLE ON
- SET TOP MARGIN TO 3
- SET BOTTOM MARGIN TO 3
- ERASE
- RETURN
- əəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəəə